Importing and Exporting ODBC Client Data Sources

The SequeLink Data Source SyncTool allows you to export ODBC client data source definitions to data source files and distribute them to multiple end users. The SequeLink Data Source SyncTool provides two user implementations, one for the SequeLink administrator and another for the end user:

The SequeLink for ODBC Data Source SyncTool Administrator is used by the SequeLink administrator to create data source files. It can import and export data sources. This tool should be made available to the SequeLink administrator only.
The SequeLink for ODBC Data Source SyncTool is used by the end user and can import data sources only. It should be installed on every SequeLink Client for ODBC.

In addition, you can create a customized, installable image of SequeLink Client for ODBC with predefined, site-specific settings, including data source files created with the SequeLink Data Source SyncTool. This customized, installable image is called a Quick Install image. For more information about creating Quick Install images, refer to the SequeLink Installation Guide.

The window title bar of the SequeLink Data Source SyncTool indicates whether you, or the end user, is performing an export or an import operation. Also, context-sensitive online help is available by clicking ? on the title bar; then, click the area about which you want more information.

Exporting ODBC Client Data Sources

From the SequeLink program manager group, double-click the ODBC Data Source SyncTool Administrator icon. The SequeLink for ODBC Data Source SyncTool Administrator Welcome window appears.
Select the Manage Data Sources Files option; then, click Next.
Select a data source file from the Filename list box, or click Browse to find a data source file not listed. The default extension for a data source file is .DSF.

To create a new data source file, click New.

Select whether you want to export User or System data sources to the data source file you selected; then click Next.
Select the data sources you want to export to the data source file.

NOTE: You cannot export grayed-out data sources, which are data sources that are configured for a previous incompatible version of the ODBC driver.

Using the following symbols, verify that the appropriate actions will be performed on the data sources in the data source file; then, click Next.

	The data source will remain unchanged.
	The data source will be added to the data source file.
	The data source will be deleted from the data source file.
	The data source will be updated in the data source file.

Type a description for the data source file; then, click Next. This description will appear when the end user selects this file for importing.
Select the mode the end user will use to import these data sources; then, click Next.
Interactive mode allows the user to select which data sources will be imported. This mode is not supported by the Quick Install feature; the Quick Install feature supports only data source files created with the Merge or Overwrite options. For instructions on creating Quick Install images, refer to the SequeLink Installation Guide.
Merge mode adds or updates all the data sources in the data source file without deleting other data sources.
Overwrite mode adds or updates the data sources in the data source file and deletes any other data sources configured for the ODBC driver.
Select the option that will determine how the end user will be able to import the data sources you exported to the data source file; then, click Next.
Suggest SequeLink User DSN. When imported, the SequeLink for ODBC Data Source SyncTool will suggest to the end user that these data sources be imported as User data sources, but will allow them to be imported as User or System data sources.
Suggest SequeLink System DSN. When imported, the SequeLink for ODBC Data Source SyncTool will suggest to the end user that these data sources be imported as System data sources, but will allow them to be imported as User or System data sources.
Force SequeLink User DSN. When imported, the SequeLink for ODBC Data Source SyncTool will allow these data sources to be imported as User data sources only.
Force SequeLink System DSN. When imported, the SequeLink for ODBC Data Source SyncTool will allow these data sources to be imported as System data sources only.
Click Finish to quit.

Importing ODBC Client Data Sources

The SequeLink administrator and end user use a different implementation of the SequeLink for ODBC Data Source SyncTool to import ODBC data source definitions.

To import ODBC client data sources:

From the SequeLink program manager group, double-click the appropriate ODBC SyncTool icon. The Welcome window appears.
Select the Import option, and click Next.

NOTE: If using the SequeLink for ODBC Data Source SyncTool Administrator, select the Import Data Sources option; then, click Next.

Select a data source file from the Filename list box, or click Browse to find a data source file not listed. The default extension for data source files is .DSF.
Indicate whether you want to import the data sources in the data source file you just selected as User or System data sources; then, click Next.
Verify that the appropriate actions will be performed on the data sources on your local machine; then, click Next. Depending on the import mode that was set when the data source file was exported, you may see the following symbols:

	The data source will remain unchanged.
	The data source will be added to your local machine.
	The data source will be deleted from your local machine.
	The data source will be updated to your local machine.

NOTE: Grayed-out data sources are data sources that are configured for a previous incompatible version of the ODBC driver; these data sources will remain unchanged unless you update them in Interactive mode with a data source configured for the current version of the ODBC driver.

Click Finish to quit.